﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using QLTV_Public;
using QLTV_Data;
using System.Data;

namespace QLTV_BLL
{
  public  class CT_PhieuYeuCau_BLL
    {
      CT_PhieuYeuCau_Data ct_data = new CT_PhieuYeuCau_Data();
      public DataTable TaoBang(string sql)
      {
          return ct_data.TaoBang(sql);
      }
      public DataTable Load_GhiTra_GiaoVien(string soCaBiet)
      {
          return ct_data.Load_GhiTra_GiaoVien(soCaBiet);
      }
      public DataTable Load_GhiTra_HocVien(string soCaBiet)
      {
          return ct_data.Load_GhiTra_HocVien(soCaBiet);
      }
      public DataTable Load_TaiLieu_GhiTra(string maDocGia)
      {
        return  ct_data.Load_TaiLieu_GhiTra(maDocGia);
      }
      public DataTable Load_LichSuMuon(string maDocGia)
      {
          return ct_data.Load_LichSuMuon(maDocGia);
      }
      public DataTable LayDuLieu()
      {
          return ct_data.LayDuLieu();
      }
      public int Insert(CT_PhieuYeuCau_Public ct)
      {
          return ct_data.Insert(ct);
      }
      public DataTable Load_ChiTiet_Muon(string maPhieu)
      {
          return ct_data.Load_ChiTiet_Muon(maPhieu);
      }
      public int Update_GhiTra(CT_PhieuYeuCau_Public obj)
      {
          return ct_data.Update_GhiTra(obj);

      }
      public int Update_GiaHan(CT_PhieuYeuCau_Public obj)
      {
          return ct_data.Update_GiaHan(obj);
      }
      public DataTable Load_GiaoVien_QuaHan(string maDocGia, string hoTen, string nhanDe, Boolean isNgayMuon, DateTime tuNgayMuon, DateTime denNgayMuon, Boolean isNgayTra, DateTime tuNgayTra, DateTime denNgayTra)
      {
          return ct_data.Load_GiaoVien_QuaHan(maDocGia,hoTen,nhanDe,isNgayMuon,tuNgayMuon,denNgayMuon,isNgayTra,tuNgayTra,denNgayTra);
      }
      public DataTable Load_HocVien_QuaHan(string maDocGia, string hoTen, string nhanDe, Boolean isNgayMuon, DateTime tuNgayMuon, DateTime denNgayMuon, Boolean isNgayTra, DateTime tuNgayTra, DateTime denNgayTra)
      {
          return ct_data.Load_HocVien_QuaHan(maDocGia, hoTen, nhanDe, isNgayMuon, tuNgayMuon, denNgayMuon, isNgayTra, tuNgayTra, denNgayTra);
      }
      public int Update_SoLuongMuon(int soLuongMuon, string maDocGia)
      {
          return ct_data.Update_SoLuongMuon(soLuongMuon,maDocGia);
      }
      public DataTable Load_ThongTinChiTiet_HocVien(string maDocGia)
      {
          return ct_data.Load_ThongTinChiTiet_HocVien(maDocGia);
      }
      public DataTable Load_ThongTinChiTiet_GiaoVien(string maDocGia)
      {
          return ct_data.Load_ThongTinChiTiet_GiaoVien(maDocGia);
      }
      public DataTable Load_GiaHan(string soCaBiet)
      {
          return ct_data.Load_GiaHan(soCaBiet);
      }
    }
}
